﻿<?xml version="1.0" encoding="utf-8" ?>
<DataStructure>
  <TableStructure>
    <Table  Name="Users" Description="用户" Type="MasterData"  ClassName="User">
      <Field Name="ObjType" Description="对象" DbType="nvarchar" PSize="max" SSize="" DefaultValue="User" PropertyName="ObjectType" IsPrimaryKey="" IsUnionKey="" IsNull=""/>
      <Field Name="UserID" Description="用户编号" DbType="int" PSize="" SSize="" DefaultValue="" PropertyName="UserID" IsPrimaryKey="Yes" IsUnionKey="" IsNull=""/>
      <Field Name="Activated" Description="可用" DbType="char" PSize="1" SSize="" DefaultValue="N" PropertyName="Activated" IsPrimaryKey="" IsUnionKey="" IsNull="">
        <ValidDataType name="BOYesOrNo">
          <ValidValue Name="Yes" value="Y" Description="是"/>
          <ValidValue Name="No" value="N" Description="否"/>
        </ValidDataType>
      </Field>
      <Field Name="Creator" Description="创建人" DbType="int" PSize="" SSize="" DefaultValue="" PropertyName="Creator" IsPrimaryKey="" IsUnionKey="" IsNull=""/>
      <Field Name="CreateDate" Description="创建时间" DbType="Datetime" PSize="" SSize="" DefaultValue="" PropertyName="CreateDate" IsPrimaryKey="" IsUnionKey="" IsNull=""/>
      <Field Name="Updator" Description="更新人" DbType="int" PSize="" SSize="" DefaultValue="" PropertyName="Updator" IsPrimaryKey="" IsUnionKey="" IsNull="Yes"/>
      <Field Name="UpdateDate" Description="更新时间" DbType="Datetime" PSize="" SSize="" DefaultValue="" PropertyName="UpdateDate" IsPrimaryKey="" IsUnionKey="" IsNull="Yes"/>      
      <Field Name="UserCode" Description="用户代码" DbType="nvarchar" PSize="30" SSize="" DefaultValue="" PropertyName="UserCode" IsPrimaryKey="" IsUnionKey="Yes" IsNull=""/>
      <Field Name="UserName" Description="用户名称" DbType="nvarchar" PSize="max" SSize="" DefaultValue="" PropertyName="UserName" IsPrimaryKey="" IsUnionKey="" IsNull="Yes"/>
      <Field Name="Password" Description="密码" DbType="nvarchar" PSize="30" SSize="" DefaultValue="" PropertyName="Password" IsPrimaryKey="" IsUnionKey="" IsNull="Yes"/>
      <Field Name="IsSupperUser" Description="超级用户" DbType="char" PSize="1" SSize="" DefaultValue="N" PropertyName="IsSupperUser" IsPrimaryKey="" IsUnionKey="" IsNull="Yes">
        <ValidDataType name="BOYesOrNo">
          <ValidValue Name="Yes" value="Y" Description="是"/>
          <ValidValue Name="No" value="N" Description="否"/>
        </ValidDataType>
      </Field>
      <Field Name="EmployeeID" Description="员工号" DbType="int" PSize="" SSize="" DefaultValue="" PropertyName="EmployeeID" IsPrimaryKey="" IsUnionKey="" IsNull="Yes"/>
      <Field Name="Branch" Description="分属\分支" DbType="nvarchar" PSize="30" SSize="" DefaultValue="" PropertyName="Branch" IsPrimaryKey="" IsUnionKey="" IsNull="Yes"/>
      <Field Name="Department" Description="部门" DbType="nvarchar" PSize="30" SSize="" DefaultValue="" PropertyName="Department" IsPrimaryKey="" IsUnionKey="" IsNull="Yes"/>
      <Field Name="Remarks" Description="备注" DbType="ntext" PSize="" SSize="" DefaultValue="" PropertyName="Remarks" IsPrimaryKey="" IsUnionKey="" IsNull="Yes"/>
    </Table>
  </TableStructure>
  <ObjectStructure>
    <Object ObjectType="MasterData" ObjectCode="User" ObjectName="用户" TableName="Users" NameSpace="User" IsLog="">
    </Object>
  </ObjectStructure>
</DataStructure>